To build a business object for a user-defined table
You must build a business object for each new user-defined table you create; until you do, the table cannot be used as a source in a query definition.
1. Create the user-defined table.
2. From Tools > User defined tables, click Build All.
3. The business object is built and prefaced with Cs (such as CsSurvey).
4. If you need binary data types (such as a character field greater than 255 characters) to display in the field list, add each type manually.
To add a binary field to the View list
When the business object is built, any character fields with a length greater than 255 characters are converted to binary data type. Fields with binary data type do not display when you select All from the View list on the Display tab in IQA. You must manually add fields of this type to the list.
1. Make sure you are in Advanced mode.
2. On the Display tab, select All from the View list.
3. Scroll to the bottom of the Display page.
4. In the SQL Expression field, enter the name of the field.
5. (optional) Enter an Alias for the field.
6. Select Add.